Many bed & breakfasts operate within and around Beamsville and they are in general cheaper than those found in Niagara on the Lake.
Schaferhof Bed & Breakfast
2746 moyer street, r.r. # 3, fenwick, 1-905-562-4929, (http://www.schaferhofbb.com). 20km from niagara falls, in the heart of the niagara region's wine country. they speak german.